<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Contents</title>
<link type="text/css" href="../../skin/page.css" rel="stylesheet">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<!--================= start Navigation Path ==================-->
<table summary="navigation path" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td nowrap="nowrap" valign="middle" bgcolor="#CFDCED" height="20"><img height="1" width="5" alt="" src="../../skin/images/spacer.gif" class="spacer"><!--===== breadcrumb trail (javascript-generated) ====--><font size="2" face="Arial, Helvetica, Sans-serif"><script src="../../skin/breadcrumbs.js" language="JavaScript" type="text/javascript"></script></font></td>
</tr>
<tr>
<td bgcolor="#4C6C8F" height="2"><img height="2" width="2" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
</table>
<!--================= end Navigation Path ==================-->
<!--================= start Banner ==================-->
<table summary="header with logos" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<!--================= start Group Logo ==================-->
<td bgcolor="#294563"><a href="http://incubator.apache.org"><img border="0" class="logoImage" alt="" src="../../resources/images/apache-incubator.png" title="Derby is a zero admin java based embedded database."></a></td>
<!--================= end Group Logo ==================-->
<!--================= start Project Logo ==================--><td width="100%" align="center" bgcolor="#294563"><a href="http://incubator.apache.org/derby/"><img border="0" class="logoImage" alt="Derby" src="../../images/derby-logo.jpg" title="Derby is a zero admin java based embedded database."></a></td>
<!--================= end Project Logo ==================-->
<!--================= start Search ==================--><td valign="top" rowspan="2" bgcolor="#294563">
<form target="_blank" action="http://www.google.com/search" method="get">
<table summary="search" border="0" cellspacing="0" cellpadding="0" bgcolor="#4C6C8F">
<tr>
<td colspan="3"><img height="10" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td><img height="1" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td nowrap="nowrap"><input value="incubator.apache.org" name="sitesearch" type="hidden"><input size="15" name="q" id="query" type="text"><img height="1" width="5" alt="" src="../../skin/images/spacer.gif" class="spacer"><input name="Search" value="Search" type="submit">
<br>
<font face="Arial, Helvetica, Sans-serif" size="2" color="white">
                      the Derby site
                      
                      
                    </font></td><td><img height="1" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td><img alt="" border="0" height="10" width="9" src="../../skin/images/search-left.gif"></td><td><img height="1" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td><img alt="" border="0" height="10" width="9" src="../../skin/images/search-right.gif"></td>
</tr>
</table>
</form>
</td>
<!--================= start Search ==================--><td bgcolor="#294563"><img height="10" width="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td valign="bottom" bgcolor="#294563" colspan="2">
<!--================= start Tabs ==================-->
<div class="tab">
<table summary="tab bar" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="6"><img alt="" height="8" width="6" src="../../skin/images/spacer.gif"></td><td valign="bottom">
<table summary="non selected tab" style="height: 1.6em" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" width="5" bgcolor="#B2C4E0"><img height="5" width="5" alt="" src="../../skin/images/tab-left.gif"></td><td valign="middle" bgcolor="#B2C4E0"><a class="base-not-selected" href="../../index.html">Home</a></td><td valign="top" width="5" bgcolor="#B2C4E0"><img height="5" width="5" alt="" src="../../skin/images/tab-right.gif"></td>
</tr>
<tr>
<td colspan="3" height="1"></td>
</tr>
</table>
</td><td width="6"><img alt="" height="8" width="6" src="../../skin/images/spacer.gif"></td><td valign="bottom">
<table summary="selected tab" style="height: 1.8em" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" width="5" bgcolor="#4C6C8F"><img height="5" width="5" alt="" src="../../skin/images/tabSel-left.gif"></td><td valign="middle" bgcolor="#4C6C8F"><font color="#ffffff" size="2" face="Arial, Helvetica, Sans-serif"><b><a class="base-selected" href="../../manuals/index.html">Manuals</a></b></font></td><td valign="top" width="5" bgcolor="#4C6C8F"><img height="5" width="5" alt="" src="../../skin/images/tabSel-right.gif"></td>
</tr>
</table>
</td><td width="6"><img alt="" height="8" width="6" src="../../skin/images/spacer.gif"></td><td valign="bottom">
<table summary="non selected tab" style="height: 1.6em" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" width="5" bgcolor="#B2C4E0"><img height="5" width="5" alt="" src="../../skin/images/tab-left.gif"></td><td valign="middle" bgcolor="#B2C4E0"><a class="base-not-selected" href="../../papers/index.html">Papers</a></td><td valign="top" width="5" bgcolor="#B2C4E0"><img height="5" width="5" alt="" src="../../skin/images/tab-right.gif"></td>
</tr>
<tr>
<td colspan="3" height="1"></td>
</tr>
</table>
</td>
</tr>
</table>
</div>
<!--================= end Tabs ==================-->
</td><td bgcolor="#294563"><img alt="" width="1" height="1" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td bgcolor="#4C6C8F" colspan="4"><img width="1" height="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
</table>
<!--================= end Banner ==================-->
<!--================= start Menu, NavBar, Content ==================-->
<table summary="page content" bgcolor="#ffffff" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top">
<table summary="menu" border="0" cellspacing="0" cellpadding="0">
<tr>
<!--================= start left top NavBar ==================-->
<td rowspan="3" valign="top">
<table summary="blue line" border="0" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#294563"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td bgcolor="#CFDCED"><font color="#4C6C8F" size="4" face="Arial, Helvetica, Sans-serif">&nbsp;</font></td>
</tr>
<tr>
<td bgcolor="#294563"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
</table>
</td>
<!--================= end left top NavBar ==================--><td bgcolor="#294563"><img width="1" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td valign="bottom" bgcolor="#4C6C8F"><img width="10" height="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td nowrap="nowrap" valign="top" bgcolor="#4C6C8F">
<!--================= start Menu items ==================-->
<div class="menu">
<ul>
<li>
<font color="#CFDCED">Manuals</font>
<ul>
     
<li>
<a href="../../manuals/index.html">About</a>
</li>
     
<li>
<font color="#CFDCED">Getting Started</font>
<ul>
         
<li>
<a href="../../manuals/getstart/gspr02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/getstart/gspr40.html" title="Index">Index</a>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
     
</ul>
</li>
     
<li>
<font color="#CFDCED">Reference Manual</font>
<ul>
         
<li>
<a href="../../manuals/reference/sqlj02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/reference/sqlj275.html" title="Index">Index</a>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
     
</ul>
</li>

     
<li>
<font color="#CFDCED">Developer's Guide</font>
<ul>
         
<li>
<a href="../../manuals/develop/develop02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/develop/develop157.html" title="Index">Index</a>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
     
</ul>
</li>
     
<li>
<font color="#CFDCED">Tuning Derby</font>
<ul>
         
<li>
<span class="sel"><font color="#ffcc00">Table of Contents</font></span>
</li>
         
<li>
<a href="../../manuals/tuning/perf121.html" title="Index">Index</a>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
     
</ul>
</li>

     
<li>
<font color="#CFDCED">Server &amp; Admin Guide</font>
<ul>
         
<li>
<a href="../../manuals/admin/hubprnt02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/admin/hubprnt65.html" title="Index">Index</a>
</li>
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
        
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
    
</ul>
</li>

    
<li>
<font color="#CFDCED">Tools &amp; Utility Guide</font>
<ul>
         
<li>
<a href="../../manuals/tools/tools02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/tools/tools113.html" title="Index">Index</a>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
    
</ul>
</li>
  
</ul>
</li>
</ul>
</div>
<!--================= end Menu items ==================-->
</td><td valign="bottom" bgcolor="#4C6C8F"><img width="10" height="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td bgcolor="#294563"><img width="1" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td valign="bottom" align="left" colspan="2" rowspan="2" bgcolor="#4C6C8F"><img height="10" width="10" border="0" alt="" src="../../skin/images/menu-left.gif"></td><td bgcolor="#4C6C8F"><img height="10" width="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td valign="bottom" align="right" colspan="2" rowspan="2" bgcolor="#4C6C8F"><img height="10" width="10" border="0" alt="" src="../../skin/images/menu-right.gif"></td>
</tr>
<tr>
<td height="1" bgcolor="#294563"><img width="1" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
</table>
</td><td valign="top" width="100%">
<table summary="content" width="100%" border="0" cellpadding="0" cellspacing="0">
<!--================= start middle NavBar ==================-->
<tr>
<td colspan="4" bgcolor="#294563"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td align="left" width="10" bgcolor="#CFDCED"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td align="left" width="50%" bgcolor="#CFDCED"><font color="#4C6C8F" size="3" face="Arial, Helvetica, Sans-serif">
                &nbsp;
                
                </font><img width="10" height="8" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td align="right" width="50%" bgcolor="#CFDCED"><font color="#4C6C8F" size="3" face="Arial, Helvetica, Sans-serif">
                &nbsp;
                
                </font><img width="10" height="8" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td width="10" bgcolor="#CFDCED"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td colspan="4" bgcolor="#294563"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<!--================= end middle NavBar ==================-->
<!--================= start Content==================-->
<tr>
<td align="left" width="10"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td colspan="2" align="left" width="100%">
<div class="content">
<table class="title" summary="">
<tr>
<td valign="middle">
<h1>Contents</h1>
</td>
</tr>
</table>
<ul class="minitoc">
<li>
<a href="#Tuning+Derby">Tuning Derby</a>
</li>
<li>
<a href="#Contents">Contents</a>
</li>
</ul>
<a name="N10036"></a><a name="Tuning+Derby"></a>
<h3>Tuning Derby</h3>
<div style="margin-left: 0 ; border: 2px">
<br>
<hr>
</div>
<a name="N1003C"></a><a name="Contents"></a>
<h3>Contents</h3>
<div style="margin-left: 0 ; border: 2px">
<p>
<a href="perf.html">Copyright</a>
<br>
</p>
<p>
<a href="perf03.html#HDRPROPREF1002477">About This Document</a>
<br>
</p>
<ul>
<li>
<a href="perf04.html#HDRSII-PROPREF-11181">Purpose of This Document</a>
</li>
<li>
<a href="perf05.html#HDRSII-PROPREF-22460">Audience</a>
</li>
<li>
<a href="perf06.html#HDRSII-PROPREF-23947">How This Document Is Organized</a>
</li>
</ul>
<p>
<a href="perf07.html#HDRSII-SETPROP-34818">Working with Derby Properties</a>
<br>
</p>
<ul>
<li>
<a href="perf08.html#HDRSII-SETPROP-11108">Properties overview</a> 
<ul>
<li>
<a href="perf09.html#HDRSETPROP824451">Scope of Properties</a>
</li>
<li>
<a href="perf10.html#HDRSETPROP824500">Persistence of Properties</a>
</li>
<li>
<a href="perf11.html#HDRSII-SETPROP-23308">Precedence of Properties</a> 
<ul>
<li>
<a href="perf11.html#HDRSETPROP824533">Protection of Database-Wide Properties</a>
</li>
</ul>
</li>
<li>
<a href="perf12.html#HDRSETPROP824615">Dynamic versus Static Properties</a>
</li>
</ul>
</li>
<li>
<a href="perf13.html#HDRSII-SETPROP-24222">Ways of Setting Derby Properties</a> 
<ul>
<li>
<a href="perf14.html#HDRSII-SETPROP-16827">System-Wide Properties</a> 
<ul>
<li>
<a href="perf14.html#HDRSII-SETPROP-11561">Changing the system-wide properties programmatically</a>
</li>
<li>
<a href="perf14.html#HDRSII-SETPROP-13074">In the <strong>derby.properties</strong> File</a>
</li>
<li>
<a href="perf14.html#HDRSETPROP824983">Verifying System Properties</a>
</li>
</ul>
</li>
<li>
<a href="perf15.html#HDRSII-SETPROP-12821">Database-Wide Properties</a>
</li>
<li>
<a href="perf16.html#HDRSII-SETPROP-24843">In a Client/Server Environment</a>
</li>
<li>
<a href="perf17.html#HDRSII-SETPROP-44147">Dynamic or Static Changes to Properties</a>
</li>
</ul>
</li>
<li>
<a href="perf18.html#HDRSII-SETPROP-32443">Properties case study</a>
</li>
</ul>
<p>
<a href="perf19.html#HDRSII-PERF-22457">Performance tips and tricks</a>
<br>
</p>
<ul>
<li>
<a href="perf20.html#HDRSII-PERF-25864">The tips</a> 
<ul>
<li>
<a href="perf21.html#HDRSII-PERF-18705">Use prepared statements with substitution parameters</a>
</li>
<li>
<a href="perf22.html#HDRSII-PERF-10679">Create Indexes, and Make Sure They're Being Used</a>
</li>
<li>
<a href="perf23.html#HDRSII-PERF-54492">Increase the Size of the Data Page Cache</a>
</li>
<li>
<a href="perf24.html#HDRSII-PERF-10065">Tune the size of database pages</a> 
<ul>
<li>
<a href="perf24.html#HDRPERF816059">Performance trade-offs of large pages</a>
</li>
</ul>
</li>
<li>
<a href="perf25.html#HDRSII-PERF-23868">Avoid expensive queries</a>
</li>
<li>
<a href="perf26.html#HDRSII-PERF-98197">Use the appropriate getXXX and setXXX methods for the type</a>
</li>
<li>
<a href="perf27.html#HDRSII-PERF-16556">Tune database booting/class loading</a>
</li>
</ul>
</li>
<li>
<a href="perf28.html#HDRSII-PERF-31086">More tips</a> 
<ul>
<li>
<a href="perf29.html#HDRSII-PERF-17936">Shut down the system properly</a>
</li>
<li>
<a href="perf30.html#HDRPERF816635">Put Derby first in your class path</a>
</li>
</ul>
</li>
</ul>
<p>
<a href="perf31.html#HDRSII-DEPTH-39739">Tuning databases and applications</a>
<br>
</p>
<ul>
<li>
<a href="perf32.html#HDRSII-DEPTH-21935">Application and database design issues</a> 
<ul>
<li>
<a href="perf33.html#HDRSII-DEPTH-10525">Avoiding table scans of large tables</a> 
<ul>
<li>
<a href="perf33.html#HDRSII-DEPTH-23033">Index, Index, Index</a>
</li>
<li>
<a href="perf33.html#HDRSII-DEPTH-36205">Prevent the user from issuing expensive queries</a>
</li>
</ul>
</li>
<li>
<a href="perf34.html#HDRSII-DEPTH-29804">Avoiding compiling SQL statements</a> 
<ul>
<li>
<a href="perf34.html#HDRSII-DEPTH-32379">Using the statement cache</a>
</li>
</ul>
</li>
<li>
<a href="perf35.html#HDRSII-DEPTH-14326">Shielding users from Derby class-loading events</a>
</li>
</ul>
</li>
<li>
<a href="perf36.html#HDRSII-DEPTH-33391">Analyzing Statement Execution</a>
</li>
<li>
<a href="perf37.html#HDRSII-DEPTH-13055">Working with RunTimeStatistics</a> 
<ul>
<li>
<a href="perf38.html#HDRSII-DEPTH-26674">Overview</a>
</li>
<li>
<a href="perf39.html#HDRSII-DEPTH-34375">How You Use It</a>
</li>
<li>
<a href="perf40.html#HDRSII-DEPTH-37648">Analyzing the Information</a> 
<ul>
<li>
<a href="perf40.html#HDRDEPTH853095">Statistics Timing</a>
</li>
<li>
<a href="perf40.html#HDRDEPTH853133">Statement Execution Plan</a>
</li>
<li>
<a href="perf40.html#HDRDEPTH853228">Optimizer estimates</a>
</li>
</ul>
</li>
</ul>
</li>
</ul>
<p>
<a href="perf41.html#HDRSII-OPTIMZ-39739">DML statements and performance</a>
<br>
</p>
<ul>
<li>
<a href="perf42.html#HDRSII-OPTIMZ-23977">Performance and optimization</a> 
<ul>
<li>
<a href="perf43.html#HDRSII-OPTIMZ-30217">Index use and access paths</a> 
<ul>
<li>
<a href="perf43.html#HDRSII-OPTIMZ-33368">What Is an Index?</a>
</li>
<li>
<a href="perf43.html#HDRSII-OPTIMZ-39106">What's Optimizable?</a>
</li>
<li>
<a href="perf43.html#HDRSII-OPTIMZ-30768">Covering Indexes</a>
</li>
<li>
<a href="perf43.html#HDRSII-OPTIMZ-41314">Useful Indexes Can Use Qualifiers</a>
</li>
<li>
<a href="perf43.html#HDRSII-OPTIMZ-22900">When a Table Scan Is Better</a>
</li>
<li>
<a href="perf43.html#HDROPTIMZ856914">Indexes Have a Cost for Inserts, Updates, and Deletes</a>
</li>
</ul>
</li>
<li>
<a href="perf44.html#HDRSII-OPTIMZ-12168">Joins and Performance</a> 
<ul>
<li>
<a href="perf44.html#HDROPTIMZ857385">Join Order Overview</a>
</li>
<li>
<a href="perf44.html#HDRSII-OPTIMZ-23173">Join Strategies</a>
</li>
</ul>
</li>
<li>
<a href="perf45.html#HDRSII-OPTIMZ-42425">Derby's Cost-Based Optimization</a> 
<ul>
<li>
<a href="perf45.html#HDRSII-OPTIMZ-32184">About the Optimizer's Choice of Access Path</a>
</li>
<li>
<a href="perf45.html#HDRSII-OPTIMZ-20327">About the Optimizer's Choice of Join Order</a>
</li>
<li>
<a href="perf45.html#HDRSII-OPTIMZ-11941">About the Optimizer's Choice of Join Strategy</a>
</li>
<li>
<a href="perf45.html#HDRSII-OPTIMZ-27036">About the Optimizer's Choice of Sort Avoidance</a>
</li>
<li>
<a href="perf45.html#HDRSII-OPTIMZ-19357">About the System's Selection of Lock Granularity</a>
</li>
<li>
<a href="perf45.html#HDRSII-OPTIMZ-29384">About the Optimizer's Selection of Bulk Fetch</a>
</li>
</ul>
</li>
</ul>
</li>
<li>
<a href="perf46.html#HDRSII-OPTIMZ-27975">Locking and Performance</a> 
<ul>
<li>
<a href="perf47.html#HDRSII-OPTIMZ-42065">Transaction-Based Lock Escalation</a>
</li>
<li>
<a href="perf48.html#HDRSII-OPTIMZ-11775">LOCK TABLE Statement</a>
</li>
</ul>
</li>
<li>
<a href="perf49.html#HDROPTIMZ860097">Non-Cost-Based Optimizations</a> 
<ul>
<li>
<a href="perf50.html#HDRSII-OPTIMZ-22460">Non-Cost-Based Sort Avoidance (Tuple Filtering)</a> 
<ul>
<li>
<a href="perf50.html#HDROPTIMZ859947">DISTINCT</a>
</li>
<li>
<a href="perf50.html#HDROPTIMZ859974">GROUP BY</a>
</li>
</ul>
</li>
<li>
<a href="perf51.html#HDRSII-OPTIMZ-22111">The MIN() and MAX() Optimizations</a>
</li>
</ul>
</li>
</ul>
<p>
<a href="perf52.html#HDRSII-STATS-18908">Selectivity and Cardinality Statistics</a>
<br>
</p>
<ul>
<li>
<a href="perf53.html#HDRSII-STATS-98996">Overview</a> 
<ul>
<li>
<a href="perf54.html#HDRSII-STATS-57793">Determinations of Rows Scanned From Disk For a Table Scan</a> 
<ul>
<li>
<a href="perf54.html#HDRSTATS848901">How the Optimizer Determines the number of Rows in a Table</a>
</li>
</ul>
</li>
<li>
<a href="perf55.html#HDRSII-STATS-60669">Estimations of Rows Scanned From Disk for an Index Scan</a> 
<ul>
<li>
<a href="perf55.html#HDRSTATS848961">Queries with a Known Search Condition</a>
</li>
<li>
<a href="perf55.html#HDRSTATS849000">Queries with an Unknown Search Condition</a>
</li>
</ul>
</li>
<li>
<a href="perf56.html#HDRSTATS849203">Statistics-Based versus Hard-Wired Selectivity</a> 
<ul>
<li>
<a href="perf56.html#HDRSII-STATS-72938">Selectivity From Cardinality Statistics</a>
</li>
<li>
<a href="perf56.html#HDRSII-STATS-52657">Selectivity From Hard-Wired Assumptions</a>
</li>
</ul>
</li>
<li>
<a href="perf57.html#HDRSTATS849251">What Are Cardinality Statistics?</a>
</li>
</ul>
</li>
<li>
<a href="perf58.html#HDRSII-STATS-46438">Working With Cardinality Statistics</a> 
<ul>
<li>
<a href="perf59.html#HDRSII-STATS-57373">When Cardinality Statistics Are Automatically Updated</a>
</li>
<li>
<a href="perf60.html#HDRSTATS849505">When Cardinality Statistics Go Stale</a>
</li>
</ul>
</li>
</ul>
<p>
<a href="perf61.html#HDRSII-PROPER-32213">Derby Properties</a>
<br>
</p>
<ul>
<li>
<a href="perf62.html#HDRSII-PROPER-51399">Scope of Derby Properties</a>
</li>
<li>
<a href="perf63.html#HDRSII-PROPER-22250">Derby Properties</a> 
<ul>
<li>
<a href="perf64.html#HDRBABHFGGB">derby.authentication.ldap.searchAuthDN</a>
</li>
<li>
<a href="perf65.html#HDRBABCIGDJ">derby.authentication.ldap.searchAuthPW</a>
</li>
<li>
<a href="perf66.html#HDRSII-PROPER-26978">derby.authentication.ldap.searchBase</a>
</li>
<li>
<a href="perf67.html#HDRSII-PROPER-37341">derby.authentication.ldap.searchFilter</a>
</li>
<li>
<a href="perf68.html#HDRSII-PROPER-13766">derby.authentication.provider</a>
</li>
<li>
<a href="perf69.html#HDRSII-PROPER-25581">derby.authentication.server</a>
</li>
<li>
<a href="perf70.html#HDRSII-PROPER-27467">derby.connection.requireAuthentication</a>
</li>
<li>
<a href="perf71.html#HDRSII-PROPER-24846">derby.database.defaultConnectionMode</a>
</li>
<li>
<a href="perf72.html#HDRSII-PROPER-81405">derby.database.forceDatabaseLock</a>
</li>
<li>
<a href="perf73.html#HDRSII-PROPER-25025">derby.database.fullAccessUsers</a>
</li>
<li>
<a href="perf74.html#HDRSII-PROPER-24390">derby.database.propertiesOnly</a>
</li>
<li>
<a href="perf75.html#HDRSII-PROPER-39325">derby.database.readOnlyAccessUsers</a>
</li>
<li>
<a href="perf76.html#HDRSII-PROPER-13217">derby.infolog.append</a>
</li>
<li>
<a href="perf77.html#HDRSII-PROPER-43517">derby.language.logStatementText</a>
</li>
<li>
<a href="perf78.html#HDRSII-PROPER-10607">derby.locks.deadlockTimeout</a>
</li>
<li>
<a href="perf79.html#HDRSII-PROPER-23835">derby.locks.deadlockTrace</a>
</li>
<li>
<a href="perf80.html#HDRSII-PROPER-40346">derby.locks.escalationThreshold</a>
</li>
<li>
<a href="perf81.html#HDRSII-PROPER-98166">derby.locks.monitor</a>
</li>
<li>
<a href="perf82.html#HDRSII-PROPER-46141">derby.locks.waitTimeout</a>
</li>
<li>
<a href="perf83.html#HDRSII-PROPER-27529">derby.storage.initialPages</a>
</li>
<li>
<a href="perf84.html#HDRBABGEJBA">derby.storage.minimumRecordSize</a>
</li>
<li>
<a href="perf85.html#HDRSII-PROPER-81359">derby.storage.pageCacheSize</a>
</li>
<li>
<a href="perf86.html#HDRSII-PROPER-28026">derby.storage.pageReservedSpace</a>
</li>
<li>
<a href="perf87.html#HDRSII-PROPER-40688">derby.storage.pageSize</a>
</li>
<li>
<a href="perf88.html#HDRSII-PROPER-34037">derby.storage.tempDirectory</a>
</li>
<li>
<a href="perf89.html#HDRSII-PROPER-18151">derby.stream.error.file</a>
</li>
<li>
<a href="perf90.html#HDRSII-PROPER-26985">derby.stream.error.logSeverityLevel</a>
</li>
<li>
<a href="perf91.html#HDRSII-PROPER-32066">derby.system.home</a>
</li>
<li>
<a href="perf92.html#HDRSII-PROPER-27355">derby.user.<strong>UserName</strong></a>
</li>
</ul>
</li>
</ul>
<p>
<a href="perf93.html#HDRSII-TRANSFORM-13966">Appendix A. Internal Language Transformations</a>
<br>
</p>
<ul>
<li>
<a href="perf94.html#HDRSII-TRANSFORM-35783">Predicate Transformations</a> 
<ul>
<li>
<a href="perf95.html#HDRSII-TRANSFORM-17139">BETWEEN Transformations</a>
</li>
<li>
<a href="perf96.html#HDRSII-TRANSFORM-37208">LIKE Transformations</a> 
<ul>
<li>
<a href="perf96.html#HDRSII-TRANSFORM-36845">Character String Beginning with Constant</a>
</li>
<li>
<a href="perf96.html#HDRSII-TRANSFORM-34043">Character String Without Wildcards</a>
</li>
<li>
<a href="perf96.html#HDRSII-TRANSFORM-14272">Unknown Parameter</a>
</li>
</ul>
</li>
<li>
<a href="perf97.html#HDRSII-TRANSFORM-11852">Static IN Predicate Transformations</a> 
<ul>
<li>
<a href="perf97.html#HDRTRANSFORM866214">NOT IN Predicate Transformations</a>
</li>
</ul>
</li>
<li>
<a href="perf98.html#HDRSII-TRANSFORM-15090">OR Transformations</a>
</li>
</ul>
</li>
<li>
<a href="perf99.html#HDRSII-TRANSFORM-37032">Transitive Closure</a> 
<ul>
<li>
<a href="perf100.html#HDRTRANSFORM866547">Transitive Closure on Join Clauses</a>
</li>
<li>
<a href="perf101.html#HDRTRANSFORM866587">Transitive Closure on Search Clauses</a>
</li>
</ul>
</li>
<li>
<a href="perf102.html#HDRSII-TRANSFORM-11313">View Transformations</a> 
<ul>
<li>
<a href="perf103.html#HDRSII-TRANSFORM-22576">View Flattening</a>
</li>
<li>
<a href="perf104.html#HDRSII-TRANSFORM-36623">Predicates Pushed into Views or Derived Tables</a>
</li>
</ul>
</li>
<li>
<a href="perf105.html#HDRSII-TRANSFORM-13699">Subquery Processing and Transformations</a> 
<ul>
<li>
<a href="perf106.html#HDRSII-TRANSFORM-25857">Materialization</a>
</li>
<li>
<a href="perf107.html#HDRSII-TRANSFORM-36368">Flattening a Subquery into a Normal Join</a>
</li>
<li>
<a href="perf108.html#HDRSII-TRANSFORM-25868">Flattening a Subquery into an EXISTS Join</a>
</li>
<li>
<a href="perf109.html#HDRSII-TRANSFORM-47182">Flattening VALUES Subqueries</a>
</li>
<li>
<a href="perf110.html#HDRTRANSFORM867165">DISTINCT Elimination in IN, ANY, and EXISTS Subqueries</a>
</li>
<li>
<a href="perf111.html#HDRTRANSFORM867201">IN/ANY Subquery Transformation</a>
</li>
</ul>
</li>
<li>
<a href="perf112.html#HDRSII-TRANSFORM-55045">Outer Join Transformations</a>
</li>
<li>
<a href="perf113.html#HDRSII-TRANSFORM-16033">Sort Avoidance</a> 
<ul>
<li>
<a href="perf114.html#HDRSII-TRANSFORM-16279">DISTINCT Elimination Based on a Uniqueness Condition</a>
</li>
<li>
<a href="perf115.html#HDRSII-TRANSFORM-21780">Combining ORDER BY and DISTINCT</a>
</li>
<li>
<a href="perf116.html#HDRSII-TRANSFORM-14044">Combining ORDER BY and UNION</a>
</li>
</ul>
</li>
<li>
<a href="perf117.html#HDRSII-TRANSFORM-41535">Aggregate Processing</a> 
<ul>
<li>
<a href="perf118.html#HDRTRANSFORM867602">COUNT(nonNullableColumn)</a>
</li>
</ul>
</li>
</ul>
<p>
<a href="perf120.html#HDRTRADEM">Trademarks</a>
</p>
<p>
<a href="perf121.html#HDRINDEX_START">Index</a>
<br>
</p>
<hr>
<a href="perf.html">Previous Page</a>
<br>
<a href="perf03.html">Next Page</a>
<br>
<a href="#ToC">Table of Contents</a>
<br>
<a href="perf121.html#HDRINDEX_START">Index</a>
</div>
<div class="attribution"></div>
</div>
</td><td width="10"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<!--================= end Content==================-->
</table>
</td>
</tr>
</table>
<!--================= end Menu, NavBar, Content ==================-->
<!--================= start Footer ==================-->
<table summary="footer" cellspacing="0" cellpadding="0" width="100%" border="0">
<tr>
<td colspan="2" height="1" bgcolor="#4C6C8F"><img height="1" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"><a href="../../skin/images/label.gif"></a><a href="../../skin/images/page.gif"></a><a href="../../skin/images/chapter.gif"></a><a href="../../skin/images/chapter_open.gif"></a><a href="../../skin/images/current.gif"></a><a href="/favicon.ico"></a></td>
</tr>
<tr>
<td colspan="2" bgcolor="#CFDCED" class="copyright" align="center"><font size="2" face="Arial, Helvetica, Sans-Serif">Copyright &copy;
          2004&nbsp;Apache Software Foundation All rights reserved.<script type="text/javascript" language="JavaScript"><!--
              document.write(" - "+"Last Published: " + document.lastModified);
            //  --></script></font></td>
</tr>
<tr>
<td colspan="2" align="left" bgcolor="#CFDCED" class="logos"></td>
</tr>
</table>
<!--================= end Footer ==================-->
</body>
</html>
